use master
go

CREATE PROCEDURE GetProductPrice
    @Price DECIMAL(18,2) OUTPUT
AS
BEGIN
    -- 假设products表有一个名为price的列来存储产品价格 
    SELECT @Price = price FROM products WHERE id = 1
END;